﻿CREATE TABLE [dbo].[Member] (
    [UserId]        INT        NOT NULL,
    [MemberClassId] INT        NULL,
    [RenewDate]     DATETIME   NULL,
    [EarnMile]      FLOAT (53) NULL,
    [CustomerId]    INT        NULL,
    CONSTRAINT [PK_Member] PRIMARY KEY CLUSTERED ([UserId] ASC),
    CONSTRAINT [FK_Member_Customer] FOREIGN KEY ([CustomerId]) REFERENCES [dbo].[Customer] ([CustomerId]),
    CONSTRAINT [FK_Member_MemberClass] FOREIGN KEY ([MemberClassId]) REFERENCES [dbo].[MemberClass] ([MemberClassId])
);

